SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_VerifyLectureIsSendEmail]
    (
      @JOL_Lecture_No INT,
      @JOL_Lecture_IsSendEmail BIT
    )
AS 
    UPDATE  dbo.JOL_Lecture
    SET     JOL_Lecture_IsSendEmail = @JOL_Lecture_IsSendEmail
    WHERE   JOL_Lecture_No = @JOL_Lecture_No
GO
